23. Video: WHERE

WHERE Statements

Using the WHERE statement, we can display subsets of tables based on conditions that must be met. You can also think of the WHERE command as filtering the data.

This video above shows how this can be used, and in the upcoming concepts, you will learn some common operators that are useful with the WHERE' statement.

Common symbols used in WHERE statements include:

  1. > (greater than)

  2. < (less than)

  3. >= (greater than or equal to)

  4. <= (less than or equal to)

  5. = (equal to)

  6. != (not equal to)

Next Concept